﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
			   SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO [dbo].[Employees] ([FirstName],[LastName],[Email],DOB,IsDOBCulculated,GenderCode,DepartmentId,MaritalStatusCode,NationalityCode,IsConsultant,aCTIVE,Title,
EmployeeType,HomeAddress,HomeCity,HomeCountryCode,WorkCountryCode,WorkAddress,WorkCity )         
  VALUES('Mohammad','Nadeem','nadeemlari@gmail.com',GETDATE(),1,'M',1,'M','IN',1,1,1,1,'F85',
  'New Delhi','IN','IN','F85','NDelhi')



--- App module insert script-----------------------------------
INSERT INTO [AppModules] ([ID] ,[Caption],Sequenc)
	 VALUES   (1,'Core System',1)

INSERT INTO [AppModules] ([ID] ,[Caption],Sequenc)
	 VALUES   (2,'Front Office',2)

INSERT INTO [AppModules] ([ID] ,[Caption],Sequenc)
	 VALUES   (3,'OPD',3)

INSERT INTO [AppModules] ([ID] ,[Caption],Sequenc)
	 VALUES   (4,'User Management',4)

INSERT INTO [AppModules] ([ID] ,[Caption],Sequenc)
	 VALUES   (5,'Master Management',5)

INSERT INTO [AppModules] ([ID] ,[Caption],Sequenc)
	 VALUES   (6,'HR Master',6)
--Role Insert script-------------------------------------------------------------------  
INSERT INTO [Roles]([Name]) VALUES ('Admin')
INSERT INTO [Roles]([Name]) VALUES ('Front Office')
INSERT INTO [Roles]([Name]) VALUES ('General Staff')

go

-- Insert script for Accesses for '
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (1,1,'Search Oatient',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (2,2,'Search Record',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (3,3,'Search xyz',0,null)

-- Access for User Management id range 101-200
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (101,4,'Manage Role',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (102,4,'Modify Role',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (103,4,'Create Role',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (104,4,'Add Employee/User',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (105,4,'View Employee/User',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (106,4,'Edit Employee/User',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (107,4,'Reset Password',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (108,4,'De-Activate User',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (109,4,'Activate User',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (110,4,'Search Employee & User',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (111,4,'Admin Glance',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (112,4,'Change Role of User',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (113,4,'Manage Specialization for consultant',0,null)

-- Access for Master Management id range 201-500
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (201,5,'Manage Genders',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (202,5,'Modify Gender',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (203,5,'Create Gender',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (207,5,'List Countries',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (208,5,'Modify Country',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (209,5,'Create Country',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (212,5,'List States',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (213,5,'Modify State',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (214,5,'Create State',0,null)


INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (215,5,'List Religion',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (216,5,'Modify Religion',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (217,5,'Create Religion',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (218,5,'List Marital Status',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (219,5,'Modify Marital Status',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (220,5,'Create Marital Status',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (221,5,'List Employee Type',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (222,5,'Modify Employee Type',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (223,5,'Create Employee Type',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (224,5,'List Titles',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (225,5,'Title Modify',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (226,5,'Create Title',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (227,5,'List Bloodgroups',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (228,5,'Bloodgroup Modify',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (229,5,'Blodgroup Create',0,null)


INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (230,5,'List Designations',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (231,5,'Designation Modify',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (232,5,'Designation Create',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (233,5,'List Departments',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (234,5,'Department Modify',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (235,5,'Department Create',0,null)

 INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (236,5,'View Department Designation Mapping',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (237,5,'Modify  Department Designation Mapping',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (238,5,'Delete  Department Designation Mapping',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (239,5,'View Department Specialization Mapping',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (240,5,'Create  Department Specialization Mapping',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (241,5,'Modify  Department Specialization Mapping',0,null)

INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (242,5,'Delete  Department Specialization Mapping',0,null)

---------------- Hr Master ------------------------------------------				
 INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (301,6,'View Qualifications',0,null)  
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (302,6,'Edit Qualifications',0,null)
INSERT INTO [Accesses]  ([ID],[ModuleId] ,[Name] ,[Level] ,[ParentId])
	 VALUES (303,6,'Create Qualifications',0,null)  
	   
go

-- Grant manage role access to Admin
declare @adminrole as int
set @adminrole = (select ID from Roles where Name='Admin')

INSERT INTO [RoleAccess] ([RoleId] ,[AccessId],[IsEnabled])
	 VALUES (@adminrole,101,1)
INSERT INTO [RoleAccess] ([RoleId] ,[AccessId],[IsEnabled])
	 VALUES (@adminrole,102,1)
INSERT INTO [RoleAccess] ([RoleId] ,[AccessId],[IsEnabled])
	 VALUES (@adminrole,103,1)
		   

declare @ID as int
set @ID = (select tOP(1)ID from Employees where [Email]='nadeemlari@gmail.com')
INSERT INTO [dbo].[Users]([EmployeeID],[UserId],[Password],[RoleID] )  VALUES   (@ID,'nadeem','4tYjoTR1tb6HbMVtXFDFDw==',@adminrole)
--password is nadeemlari
--update Users set RoleID=@adminrole where UserId='nadeem'          
GO
-- insert scripts for genders
delete from genders
insert into Genders (code,name) values('M','Male')
insert into Genders (code,name) values('F','Female')
insert into Genders (code,name) values('N','Not Aplicable')

go
-- insert script for countries
delete from countries
insert into countries(code,name) values('CA','Canada')
insert into countries(code,name) values('US','United States')
insert into countries(code,name) values('GB','United Kingdom')
insert into countries(code,name) values('AD','Andorra')
insert into countries(code,name) values('AI','Anguilla')
insert into countries(code,name) values('AR','Argentina')
insert into countries(code,name) values('AW','Aruba')
insert into countries(code,name) values('AU','Australia')
insert into countries(code,name) values('AT','Austria')
insert into countries(code,name) values('BS','Bahamas')
insert into countries(code,name) values('BH','Bahrain')
insert into countries(code,name) values('BB','Barbados')
insert into countries(code,name) values('BE','Belgium')
insert into countries(code,name) values('BM','Bermuda')
insert into countries(code,name) values('BW','Botswana')
insert into countries(code,name) values('BR','Brazil')
insert into countries(code,name) values('VG','British Virgin Islands')
insert into countries(code,name) values('BN','Brunei')
insert into countries(code,name) values('CV','Cape Verde')
insert into countries(code,name) values('KY','Cayman Islands')
insert into countries(code,name) values('CL','Chile')
insert into countries(code,name) values('C2','China')
insert into countries(code,name) values('CR','Costa Rica')
insert into countries(code,name) values('HR','Croatia')
insert into countries(code,name) values('CY','Cyprus')
insert into countries(code,name) values('CZ','Czech Republic')
insert into countries(code,name) values('DK','Denmark')
insert into countries(code,name) values('DO','Dominican Republic')
insert into countries(code,name) values('EC','Ecuador')
insert into countries(code,name) values('EE','Estonia')
insert into countries(code,name) values('FK','Falkland Islands')
insert into countries(code,name) values('FJ','Fiji')
insert into countries(code,name) values('FI','Finland')
insert into countries(code,name) values('FR','France')
insert into countries(code,name) values('GF','French Guiana')
insert into countries(code,name) values('PF','French Polynesia')
insert into countries(code,name) values('DE','Germany')
insert into countries(code,name) values('GI','Gibraltar')
insert into countries(code,name) values('GR','Greece')
insert into countries(code,name) values('GP','Guadeloupe')
insert into countries(code,name) values('HK','Hong Kong')
insert into countries(code,name) values('HU','Hungary')
insert into countries(code,name) values('IS','Iceland')
insert into countries(code,name) values('IN','India')
insert into countries(code,name) values('ID','Indonesia')
insert into countries(code,name) values('IE','Ireland')
insert into countries(code,name) values('IL','Israel')
insert into countries(code,name) values('IT','Italy')
insert into countries(code,name) values('JM','Jamaica')
insert into countries(code,name) values('JP','Japan')
insert into countries(code,name) values('JO','Jordan')
insert into countries(code,name) values('LV','Latvia')
insert into countries(code,name) values('LI','Liechtenstein')
insert into countries(code,name) values('LT','Lithuania')
insert into countries(code,name) values('LU','Luxembourg')
insert into countries(code,name) values('MY','Malaysia')
insert into countries(code,name) values('MV','Maldives')
insert into countries(code,name) values('MT','Malta')
insert into countries(code,name) values('MQ','Martinique')
insert into countries(code,name) values('YT','Mayotte')
insert into countries(code,name) values('MX','Mexico')
insert into countries(code,name) values('MS','Montserrat')
insert into countries(code,name) values('NA','Namibia')
insert into countries(code,name) values('NL','Netherlands')
insert into countries(code,name) values('AN','Netherlands Antilles')
insert into countries(code,name) values('NC','New Caledonia')
insert into countries(code,name) values('NZ','New Zealand')
insert into countries(code,name) values('NO','Norway')
insert into countries(code,name) values('PH','Philippines')
insert into countries(code,name) values('PN','Pitcairn Islands')
insert into countries(code,name) values('PL','Poland')
insert into countries(code,name) values('PT','Portugal')
insert into countries(code,name) values('QA','Qatar')
insert into countries(code,name) values('RE','Reunion')
insert into countries(code,name) values('RU','Russia')
insert into countries(code,name) values('WS','Samoa')
insert into countries(code,name) values('SG','Singapore')
insert into countries(code,name) values('SK','Slovakia')
insert into countries(code,name) values('SI','Slovenia')
insert into countries(code,name) values('SB','Solomon Islands')
insert into countries(code,name) values('ZA','South Africa')
insert into countries(code,name) values('KR','South Korea')
insert into countries(code,name) values('ES','Spain')
insert into countries(code,name) values('SH','St. Helena')
insert into countries(code,name) values('KN','St. Kitts and Nevis')
insert into countries(code,name) values('LC','St. Lucia')
insert into countries(code,name) values('PM','St. Pierre and Miquelon')
insert into countries(code,name) values('SE','Sweden')
insert into countries(code,name) values('CH','Switzerland')
insert into countries(code,name) values('TW','Taiwan')
insert into countries(code,name) values('TH','Thailand')
insert into countries(code,name) values('TG','Togo')
insert into countries(code,name) values('TO','Tonga')
insert into countries(code,name) values('TT','Trinidad and Tobago')
insert into countries(code,name) values('TN','Tunisia')
insert into countries(code,name) values('TR','Turkey')
insert into countries(code,name) values('TC','Turks and Caicos Islands')
insert into countries(code,name) values('UA','Ukraine')
insert into countries(code,name) values('AE','United Arab Emirates')
insert into countries(code,name) values('UY','Uruguay')
insert into countries(code,name) values('VE','Venezuela')
insert into countries(code,name) values('VN','Vietnam')
insert into countries(code,name) values('WF','Wallis and Futuna Islands')

go
-- insert script for states
delete from states
insert into states (code,name) values('AP','Andhra Pradesh')
insert into states (code,name) values('AR','Arunachal Pradesh')
insert into states (code,name) values('AS','Assam')
insert into states (code,name) values('BR','Bihar')
insert into states (code,name) values('CG','Chattisgarh')
insert into states (code,name) values('GA','Goa')
insert into states (code,name) values('GJ','Gujarat')
insert into states (code,name) values('HR','Haryana')
insert into states (code,name) values('HP','Himachal Pradesh')
insert into states (code,name) values('JK','Jammu & Kashmir')
insert into states (code,name) values('JH','Jharkhand')
insert into states (code,name) values('KA','Karnataka')
insert into states (code,name) values('KL','Kerala')
insert into states (code,name) values('MP','Madhya Pradesh')
insert into states (code,name) values('MH','Maharashtra')
insert into states (code,name) values('MN','Manipur')
insert into states (code,name) values('ML','Meghalaya')
insert into states (code,name) values('MZ','Mizoram')
insert into states (code,name) values('NL','Nagaland')
insert into states (code,name) values('OR','Orissa')
insert into states (code,name) values('PB','Punjab')
insert into states (code,name) values('RJ','Rajasthan')
insert into states (code,name) values('SK','Sikkim')
insert into states (code,name) values('TN','Tamil Nadu')
insert into states (code,name) values('TR','Tripura')
insert into states (code,name) values('UK','Uttarakhand')
insert into states (code,name) values('UP','Uttar Pradesh')
insert into states (code,name) values('WB','West Bengal')
insert into states (code,name) values('AN','Andaman & Nicobar')
insert into states (code,name) values('CH','Chandigarh')
insert into states (code,name) values('DN','Dadra and Nagar Haveli')
insert into states (code,name) values('DD','Daman & Diu')
insert into states (code,name) values('DL','Delhi')
insert into states (code,name) values('LD','Lakshadweep')
insert into states (code,name) values('PY','Puducherry')

go
--inset script for religions -- TBD
delete from Religions
insert into Religions (code,name) values('IS','Islam')
insert into Religions (code,name) values('NR','Nonreligious')
insert into Religions (code,name) values('HI','Hinduism')
insert into Religions (code,name) values('BU','Buddhism')
insert into Religions (code,name) values('SI','Sikhism')
insert into Religions (code,name) values('BA','Bahai')
insert into Religions (code,name) values('KA','Jainism')

go
--inset script for Marital Statuses -- TBD
delete from MaritalStatuses
insert into MaritalStatuses (code,name) values('SI','Single')
insert into MaritalStatuses (code,name) values('M','Married')
insert into MaritalStatuses (code,name) values('SE','Separated')
insert into MaritalStatuses (code,name) values('D','Divorced')
insert into MaritalStatuses (code,name) values('W','Widowed/widower')

go
--insert script for Employee types --
delete from EmployeeTypes
insert into EmployeeTypes (Name) values('Under Study')
insert into EmployeeTypes (Name) values('Regularized')
insert into EmployeeTypes (Name) values('Contract')
insert into EmployeeTypes (Name) values('Part Time')
insert into EmployeeTypes (Name) values('Full Time')
insert into EmployeeTypes (Name) values('Trainee')
insert into EmployeeTypes (Name) values('Retainer')		

go
--inset script for Titles 
delete from Titles
insert into Titles (name) values('Mr.')	
insert into Titles (name) values('Ms.')	
insert into Titles (name) values('Mast.')	
insert into Titles (name) values('Dr.')	
insert into Titles (name) values('Ambassador')	
insert into Titles (name) values('Madame')	
insert into Titles (name) values('VIP')	
insert into Titles (name) values('Excellency')	
insert into Titles (name) values('Director')	
insert into Titles (name) values('Chairman')	
insert into Titles (name) values('CEO')	
insert into Titles (name) values('GM')	
insert into Titles (name) values('ED')	
insert into Titles (name) values('RMO')	
insert into Titles (name) values('VP')	
insert into Titles (name) values('Head')	
insert into Titles (name) values('Baby')	
insert into Titles (name) values('Chairwoman')	
insert into Titles (name) values('Capt.')	
insert into Titles (name) values('ExMP')	
insert into Titles (name) values('MP')	
insert into Titles (name) values('MLA')	
insert into Titles (name) values('MRS')	
insert into Titles (name) values('MRS.')	
insert into Titles (name) values('Lt.Col.')	
insert into Titles (name) values('Col.')	
insert into Titles (name) values('Baby of')	
insert into Titles (name) values('Brig.')	
insert into Titles (name) values('LT.GEN')	

go
-- insert script for bloodgroups
delete from Bloodgroups
insert into Bloodgroups ([Name]) values('A (-ve)')
insert into Bloodgroups ([Name]) values('A (+ve)')
insert into Bloodgroups ([Name]) values('B (-ve)')
insert into Bloodgroups ([Name]) values('O  (-ve)')
insert into Bloodgroups ([Name]) values('O (+ve)')
insert into Bloodgroups ([Name]) values('AB (+ve)')
insert into Bloodgroups ([Name]) values('AB  (-ve)')
insert into Bloodgroups ([Name]) values('B (+ve)')
insert into Bloodgroups ([Name]) values('Unknown')

go
-- insert script for designations
delete from Designations
insert into Designations (Name) values('Accountant')
insert into Designations (Name) values('Accounts Assistant cum Cashier')
insert into Designations (Name) values('Area Marketing Manager')
insert into Designations (Name) values('Assistant - Medical Supplies')
insert into Designations (Name) values('Assistant - Purchase ')
insert into Designations (Name) values('Assistant - Stores')
insert into Designations (Name) values('Assistant Manager - Bio Medical ')
insert into Designations (Name) values('Assistant Manager - Projects')
insert into Designations (Name) values('Assistant Manager -Administration & Security')
insert into Designations (Name) values('Associate Dentist')
insert into Designations (Name) values('Associate Senior Consultant - Anaesthesia')
insert into Designations (Name) values('Associate Senior Consultant - Cardiology')
insert into Designations (Name) values('Associate Senior Consultant - Obs& Gynae')
insert into Designations (Name) values('Associate Senior Consultant- Dentistry')
insert into Designations (Name) values('Asst. Manager - Tranining & Development')
insert into Designations (Name) values('Audiologist')
insert into Designations (Name) values('Cardiac Surgeon')
insert into Designations (Name) values('Cardiologist')
insert into Designations (Name) values('Cardiovascular Surge')
insert into Designations (Name) values('Cardiovascular Surgn')
insert into Designations (Name) values('Chief  Information Officer')
insert into Designations (Name) values('Chief Administrator')
insert into Designations (Name) values('Chief Medical Officer')
insert into Designations (Name) values('Chief Operating Officer')
insert into Designations (Name) values('Clinical Associate')
insert into Designations (Name) values('Clinical Associate/Senior Resident')
insert into Designations (Name) values('CLINICAL PSYCHOLOGIST')
insert into Designations (Name) values('Cons - Psychiatry')
insert into Designations (Name) values('Consultant')
insert into Designations (Name) values('Consultant -  Coordinator')
insert into Designations (Name) values('Consultant - Anesthesia')
insert into Designations (Name) values('Consultant - Audiolo')
insert into Designations (Name) values('Consultant - Cardiology')
insert into Designations (Name) values('Consultant - Chest Medicine')
insert into Designations (Name) values('Consultant - Critica')
insert into Designations (Name) values('Consultant - Dentistry')
insert into Designations (Name) values('Consultant - Dermatology')
insert into Designations (Name) values('Consultant - Endocrinology')
insert into Designations (Name) values('Consultant - Endodontist')
insert into Designations (Name) values('Consultant - ENT')
insert into Designations (Name) values('Consultant - Eye Sur')
insert into Designations (Name) values('Consultant - Gastroenterologist')
insert into Designations (Name) values('Consultant - Internal Medicine')
insert into Designations (Name) values('Consultant - Internal Medicine and Family Practice')
insert into Designations (Name) values('Consultant - Medical Affairs')
insert into Designations (Name) values('Consultant - Nephrology and Hypertension')
insert into Designations (Name) values('CONSULTANT - NEUROLOGY')
insert into Designations (Name) values('Consultant - Nuclear Medicine')
insert into Designations (Name) values('Consultant - Obs & Gynecology')
insert into Designations (Name) values('Consultant - Occupational Therapist')
insert into Designations (Name) values('Consultant - Oncology')
insert into Designations (Name) values('Consultant - Orthopaedics')
insert into Designations (Name) values('Consultant - Pathology')
insert into Designations (Name) values('Consultant - Pediatric Dentistry')
insert into Designations (Name) values('Consultant - Pediatrics')
insert into Designations (Name) values('Consultant - Psychology')
insert into Designations (Name) values('CONSULTANT - PULMONOLOGY')
insert into Designations (Name) values('Consultant - Radiology')
insert into Designations (Name) values('Consultant - Rheumatology')
insert into Designations (Name) values('Consultant - Rheumatology (Paediatrics)')
insert into Designations (Name) values('Consultant - Special Educator')
insert into Designations (Name) values('Consultant - Surgica')
insert into Designations (Name) values('Consultant - Urology')
insert into Designations (Name) values('Consultant -Microbiology')
insert into Designations (Name) values('Consultant- neonatal')
insert into Designations (Name) values('Consultant Ophthal')
insert into Designations (Name) values('Consultant Paediatric Surgeon')
insert into Designations (Name) values('Consultant -Pediatrics')
insert into Designations (Name) values('Consultant- PHP')
insert into Designations (Name) values('Consultant- Rheumatology')
insert into Designations (Name) values('Consultant Speech Therapist')
insert into Designations (Name) values('Consultant/Coordinator - Internal Medicine')
insert into Designations (Name) values('Consultant/Coordinator - PHP & Emergency ')
insert into Designations (Name) values('Consultant/Coordinator - Radiology ')
insert into Designations (Name) values('Consultant-Endocinol')
insert into Designations (Name) values('Consultant-Intervent')
insert into Designations (Name) values('Consultant-Neonatalo')
insert into Designations (Name) values('Consultant-Pathology')
insert into Designations (Name) values('Consultant-Pediatrics')
insert into Designations (Name) values('Consultant-Psychiatr')
insert into Designations (Name) values('Consyltant - Critica')
insert into Designations (Name) values('Coordinator - Medical Affairs')
insert into Designations (Name) values('Coordinator - Training & Development')
insert into Designations (Name) values('Coordinator/Coordinator- Pathology')
insert into Designations (Name) values('Coordinator-HR')
insert into Designations (Name) values('Coordinator-Marketing & Customer Relations')
insert into Designations (Name) values('Co-ordinator-Operations')
insert into Designations (Name) values('Dentistry Assistant')
insert into Designations (Name) values('Deputy Director-Medical Affairs')
insert into Designations (Name) values('Deputy Manager - Accounts')
insert into Designations (Name) values('Development Therapist')
insert into Designations (Name) values('Dietician')
insert into Designations (Name) values('Dietitician')
insert into Designations (Name) values('Director -  Dept. of Anesthesia MHC')
insert into Designations (Name) values('Director- Orthopaedics')
insert into Designations (Name) values('Duty Manager')
insert into Designations (Name) values('Dy. Nursing Superintendent')
insert into Designations (Name) values('Executive - Accounts')
insert into Designations (Name) values('Executive - Administration')
insert into Designations (Name) values('Executive - Biomedical')
insert into Designations (Name) values('Executive - Commercial')
insert into Designations (Name) values('Executive - Corporate Relations')
insert into Designations (Name) values('Executive - Hospitality')
insert into Designations (Name) values('Executive - Housekeeper')
insert into Designations (Name) values('Executive - HR')
insert into Designations (Name) values('Executive - IT')
insert into Designations (Name) values('Executive - Marketing & Customer Relations')
insert into Designations (Name) values('Executive - Non Medical Supplies')
insert into Designations (Name) values('Executive - Quality Practices')
insert into Designations (Name) values('Executive - Referral Relations')
insert into Designations (Name) values('Executive Secretary')
insert into Designations (Name) values('Family Physician')
insert into Designations (Name) values('Financial Controller')
insert into Designations (Name) values('Floor Manager')
insert into Designations (Name) values('Gastroenterology-Con')
insert into Designations (Name) values('Gastrointrology-Cons')
insert into Designations (Name) values('General and Laproscopic and Endocrine Surgery')
insert into Designations (Name) values('General and Laproscopic Surgeon')
insert into Designations (Name) values('General Manager - Corporate Affairs')
insert into Designations (Name) values('General Manager -Facility Planning')
insert into Designations (Name) values('General Physician')
insert into Designations (Name) values('General Surgeon')
insert into Designations (Name) values('Head - Infrastructure')
insert into Designations (Name) values('Head Nurse')
insert into Designations (Name) values('Head -Projects')
insert into Designations (Name) values('Head-Facilities Management (Hospital Project)')
insert into Designations (Name) values('Head-Infrastrucutre')
insert into Designations (Name) values('Hemato Ocologist')
insert into Designations (Name) values('HOD Pediatrics')
insert into Designations (Name) values('Honorary Consultant')
insert into Designations (Name) values('Hub Accountant')
insert into Designations (Name) values('Hub Manager')
insert into Designations (Name) values('Junior Technician- Projects')
insert into Designations (Name) values('Manager  - Referral Relations')
insert into Designations (Name) values('Manager - Administration')
insert into Designations (Name) values('Manager - Commerical')
insert into Designations (Name) values('Manager - Human Resources')
insert into Designations (Name) values('Manager - Materials (Medical& Non-Medical)')
insert into Designations (Name) values('Manager - Operations')
insert into Designations (Name) values('Manager - Projects')
insert into Designations (Name) values('Manager – Service Quality & Hospitality Services')
insert into Designations (Name) values('Manager - Systems')
insert into Designations (Name) values('Manager -Process & Audit')
insert into Designations (Name) values('Manager-IT')
insert into Designations (Name) values('Marketing Manager')
insert into Designations (Name) values('MBBS, DMRD, DNB')
insert into Designations (Name) values('MD (AIIMS), FRCS (Gl')
insert into Designations (Name) values('Medical Director')
insert into Designations (Name) values('Medical Record Technician')
insert into Designations (Name) values('Medical Superintendent ')
insert into Designations (Name) values('MICROBIOLOGIST')
insert into Designations (Name) values('Minimal Access, Meta')
insert into Designations (Name) values('Neuro Anaesthesia')
insert into Designations (Name) values('Neurophysiotherapist')
insert into Designations (Name) values('Occupational Specialization')
insert into Designations (Name) values('Paediatric Surgeon')
insert into Designations (Name) values('Paediatrics Pulmonology')
insert into Designations (Name) values('Part Time- Audiologist')
insert into Designations (Name) values('Part Time-Duty Medical Officer')
insert into Designations (Name) values('Part-Time - Audiologist')
insert into Designations (Name) values('Part-Time - Physiotherapist')
insert into Designations (Name) values('Patient Care Co-ordinator')
insert into Designations (Name) values('Pediatric Hemato - O')
insert into Designations (Name) values('Pharmacist')
insert into Designations (Name) values('PHYSIOTHERAPIST')
insert into Designations (Name) values('Planning Engineer')
insert into Designations (Name) values('Programmer')
insert into Designations (Name) values('Project Engineer')
insert into Designations (Name) values('Radiologist')
insert into Designations (Name) values('Receptionist')
insert into Designations (Name) values('RESIDENT MEDICAL OFFICE (LOCUM)')
insert into Designations (Name) values('Resident Medical Officer')
insert into Designations (Name) values('Resident Medical Officer & Podiatry Specialist')
insert into Designations (Name) values('Secretary')
insert into Designations (Name) values('Senior Consultant - Cardiology')
insert into Designations (Name) values('Senior Consultant - Obs. and Gynae.')
insert into Designations (Name) values('Senior Consultant - Opthamology')
insert into Designations (Name) values('Senior Consultant / Advisor')
insert into Designations (Name) values('SENIOR CONSULTANT AND COORDINATOR')
insert into Designations (Name) values('Senior Consultant/Advisor- Dept. of General & Endo')
insert into Designations (Name) values('Senior Consultant/Head of the Department- Pediatri')
insert into Designations (Name) values('Senior Executive - Biomedical')
insert into Designations (Name) values('Senior Executive - Brand')
insert into Designations (Name) values('Senior Executive - Corporate Relations')
insert into Designations (Name) values('Senior Executive - IT')
insert into Designations (Name) values('Senior Executive -Commercial')
insert into Designations (Name) values('Senior Officer - Projects')
insert into Designations (Name) values('Senior Resident - Obs & Gynae')
insert into Designations (Name) values('Senior Resident - Pathology')
insert into Designations (Name) values('Senior Resident - Pediatrics')
insert into Designations (Name) values('Senior Resident -Internal Medicine')
insert into Designations (Name) values('Senior Resident -Pediatrics')
insert into Designations (Name) values('Senior Resident- Radiology')
insert into Designations (Name) values('Senior Supervisor-Projects')
insert into Designations (Name) values('Senior Technician - Cardiology')
insert into Designations (Name) values('Senior Technician - Pathology')
insert into Designations (Name) values('Senior Technician - Radiology')
insert into Designations (Name) values('Senior Technician-O.T.')
insert into Designations (Name) values('Special Educator')
insert into Designations (Name) values('Sr. Consultant & Advisor -Deptt. Of Gastroenterolo')
insert into Designations (Name) values('Sr. Consultant &Advisor- Deptt. Of Endocrinology')
insert into Designations (Name) values('Sr.Consultant Orthopedic surgeon')
insert into Designations (Name) values('Staff Nurse')
insert into Designations (Name) values('Stores - Incharge')
insert into Designations (Name) values('Supervisor -  Projects')
insert into Designations (Name) values('Supervisor-Stores')
insert into Designations (Name) values('Support Executive - HR')
insert into Designations (Name) values('SURGEON')
insert into Designations (Name) values('Surgical Oncologist')
insert into Designations (Name) values('Technician - Cardiology')
insert into Designations (Name) values('Technician - EEG/EMG')
insert into Designations (Name) values('Technician - Laboratory')
insert into Designations (Name) values('Technician - O.T.')
insert into Designations (Name) values('Technician - Optometrist')
insert into Designations (Name) values('Technician - Pathology')
insert into Designations (Name) values('Technician - Radiology')
insert into Designations (Name) values('Technician Radiology')
insert into Designations (Name) values('Technician-Dialysis')
insert into Designations (Name) values('Technician-Lithotripsy')
insert into Designations (Name) values('test designation')
insert into Designations (Name) values('Trainee Executive- Corporate Relations')
insert into Designations (Name) values('Trainee-Patient  Care Coordinator')
insert into Designations (Name) values('Trainee-Pharmacist')
insert into Designations (Name) values('Vice President - Finance')
insert into Designations (Name) values('Vice President - Human Resources')
insert into Designations (Name) values('Visiting Consultant')

go
--- insert script for departments
delete from departments
insert into Departments (Name) values('Administration')		
insert into Departments (Name) values('AMBULENCE')		
insert into Departments (Name) values('Anaesthesiology')		
insert into Departments (Name) values('Anaethesia')		
insert into Departments (Name) values('ANGIOGRAPHY')		
insert into Departments (Name) values('Angioplasty')		
insert into Departments (Name) values('ARTHRITIS')		
insert into Departments (Name) values('Audiology')		
insert into Departments (Name) values('Audiology & Speech Therapist')		
insert into Departments (Name) values('Autism & Child Development')		
insert into Departments (Name) values('BIOMEDICAL')		
insert into Departments (Name) values('Blood Bank')		
insert into Departments (Name) values('Cardiac Surgery')		
insert into Departments (Name) values('Cardiology')		
insert into Departments (Name) values('Cardiovascular Surgery')		
insert into Departments (Name) values('Cath Lab')		
insert into Departments (Name) values('Chemotherapy')		
insert into Departments (Name) values('Chest Medicine')		
insert into Departments (Name) values('Child and Adolscent Psychiatry')		
insert into Departments (Name) values('Child Development Clinic')		
insert into Departments (Name) values('CHRONIC CARE')		
insert into Departments (Name) values('Clinical Psychology')		
insert into Departments (Name) values('Commercial')		
insert into Departments (Name) values('Consumables')		
insert into Departments (Name) values('Dental')		
insert into Departments (Name) values('Dermatology')		
insert into Departments (Name) values('Dialysis')		
insert into Departments (Name) values('Diet')		
insert into Departments (Name) values('Dietician')		
insert into Departments (Name) values('EEG-Technician')		
insert into Departments (Name) values('Emergency')		
insert into Departments (Name) values('Endocrinology')		
insert into Departments (Name) values('ENDOSCOPY')		
insert into Departments (Name) values('Engineering')		
insert into Departments (Name) values('ENT')		
insert into Departments (Name) values('EPS')		
insert into Departments (Name) values('Equipmenent Charges')		
insert into Departments (Name) values('Facility Planning')		
insert into Departments (Name) values('Finance')		
insert into Departments (Name) values('Front Office')		
insert into Departments (Name) values('Gastroenterology')		
insert into Departments (Name) values('General Physician')		
insert into Departments (Name) values('General Surgery')		
insert into Departments (Name) values('Gynaecology')		
insert into Departments (Name) values('Health - Checkup')		
insert into Departments (Name) values('HEALTH CHECKUP')		
insert into Departments (Name) values('Holmium')		
insert into Departments (Name) values('Hospitality')		
insert into Departments (Name) values('House Keeping')		
insert into Departments (Name) values('Hub Managers Office')		
insert into Departments (Name) values('Human Resources')		
insert into Departments (Name) values('In Vitro Fertilisation')		
insert into Departments (Name) values('Infrastructure & Business Planning')		
insert into Departments (Name) values('Internal Medicine')		
insert into Departments (Name) values('Internal Medicine & Family Practice')		
insert into Departments (Name) values('Interventional Neurology')		
insert into Departments (Name) values('Interventional Radiology')		
insert into Departments (Name) values('Liaison')		
insert into Departments (Name) values('Lithotripsy')		
insert into Departments (Name) values('Marketing')		
insert into Departments (Name) values('MAX NEIGHB.')		
insert into Departments (Name) values('Medical Affairs')		
insert into Departments (Name) values('Medical Equipment')		
insert into Departments (Name) values('Medical Record Keeper')		
insert into Departments (Name) values('Mental and Health')		
insert into Departments (Name) values('Microbiology')		
insert into Departments (Name) values('Minimal Access Surgery')		
insert into Departments (Name) values('Miscellaneous')		
insert into Departments (Name) values('Multi Organ Transplant')		
insert into Departments (Name) values('neonatalogist')		
insert into Departments (Name) values('Nephrology')		
insert into Departments (Name) values('Neuro Surgery')		
insert into Departments (Name) values('NEUROLOGY')		
insert into Departments (Name) values('NEUROLOGY PROCEDURE')		
insert into Departments (Name) values('NICU')		
insert into Departments (Name) values('Nuclear Medicine')		
insert into Departments (Name) values('Nursing')		
insert into Departments (Name) values('Obs&Gyne')		
insert into Departments (Name) values('OCCUPATIONAL THERAPHY')		
insert into Departments (Name) values('ONCOLOGY')		
insert into Departments (Name) values('Ophthalmology')		
insert into Departments (Name) values('Optometry')		
insert into Departments (Name) values('Ortho Surgery')		
insert into Departments (Name) values('ORTHOPEDICS')		
insert into Departments (Name) values('OT')		
insert into Departments (Name) values('Other Cardiac Procedure')		
insert into Departments (Name) values('PACKAGES')		
insert into Departments (Name) values('Paediatric Endocrinology')		
insert into Departments (Name) values('Paediatrics Pulmonology')		
insert into Departments (Name) values('Pathology')		
insert into Departments (Name) values('Pediatrics')		
insert into Departments (Name) values('Pediatrics - Surgery')		
insert into Departments (Name) values('Pediatrics and Adolescent Medicine')		
insert into Departments (Name) values('Pharmacy')		
insert into Departments (Name) values('PHC - CUSTOMISED')		
insert into Departments (Name) values('PHC - STANDARD')		
insert into Departments (Name) values('Physiotherapy')		
insert into Departments (Name) values('PLASTIC SURGERY')		
insert into Departments (Name) values('PODIATRY')		
insert into Departments (Name) values('PRE EMPLOYMENT CHECKUP')		
insert into Departments (Name) values('PRE INSURANCE CHECKUP')		
insert into Departments (Name) values('Procurement & Supply Chain')		
insert into Departments (Name) values('Project Site Team')		
insert into Departments (Name) values('Projects')		
insert into Departments (Name) values('PSYCHIATRY')		
insert into Departments (Name) values('Psychology')		
insert into Departments (Name) values('PSYCOLOGY')		
insert into Departments (Name) values('Pulmonology')		
insert into Departments (Name) values('radiology')		
insert into Departments (Name) values('Radiology')		
insert into Departments (Name) values('Radiotherapy')		
insert into Departments (Name) values('Respiratory Medicine')		
insert into Departments (Name) values('Rheumatology')		
insert into Departments (Name) values('Rheumatology (Pediatric)')		
insert into Departments (Name) values('Room Charges')		
insert into Departments (Name) values('Service Charge')		
insert into Departments (Name) values('Service Quality')		
insert into Departments (Name) values('Special Educator')		
insert into Departments (Name) values('Staff Nurse')		
insert into Departments (Name) values('Stores')		
insert into Departments (Name) values('Surgery')		
insert into Departments (Name) values('Surgical Oncology')		
insert into Departments (Name) values('SWASTH HEALTH PLANS')		
insert into Departments (Name) values('Systems')		
insert into Departments (Name) values('Systems Site Team')		
insert into Departments (Name) values('Tobacco Cessation Program')		
insert into Departments (Name) values('Training & Development')		
insert into Departments (Name) values('Treatment Room')		
insert into Departments (Name) values('UROLOGY')		
insert into Departments (Name) values('Vaccine')		
insert into Departments (Name) values('vascular surgery')